Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 46406 |
| Missing cells | 250397 |
| Missing cells (%) | 24.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 7.8 MiB |
| Average record size in memory | 176.0 B |
Variable types
| Categorical | 7 |
|---|---|
| Numeric | 8 |
| Text | 6 |
| DateTime | 1 |
IDADE_ESTIMADA has constant value "0.0" | Constant |
ATIVO is highly overall correlated with IDENTIDADE_GENERO_ID and 2 other fields | High correlation |
IDENTIDADE_GENERO_ID is highly overall correlated with ATIVO | High correlation |
NUMERO_TEL_CEL is highly overall correlated with ATIVO | High correlation |
ORIENTACAO_SEXUAL_ID is highly overall correlated with ATIVO | High correlation |
PESSOA_FISICA_ID is highly overall correlated with Prontuário SIAP ? | High correlation |
Prontuário SIAP ? is highly overall correlated with PESSOA_FISICA_ID | High correlation |
ATIVO is highly imbalanced (99.8%) | Imbalance |
NACIONALIDADE_ID is highly imbalanced (98.4%) | Imbalance |
SEXO_ID is highly imbalanced (68.5%) | Imbalance |
ORIENTACAO_SEXUAL_ID is highly imbalanced (90.7%) | Imbalance |
IDENTIDADE_GENERO_ID is highly imbalanced (96.5%) | Imbalance |
IDADE_ESTIMADA has 45227 (97.5%) missing values | Missing |
NUMERO_CPF has 34913 (75.2%) missing values | Missing |
NUMERO_RG has 36031 (77.6%) missing values | Missing |
NUMERO_TEL_CEL has 38959 (84.0%) missing values | Missing |
ESTADO_ECONOMICO_ID has 8427 (18.2%) missing values | Missing |
PROFISSAO_ID has 25667 (55.3%) missing values | Missing |
ORIENTACAO_SEXUAL_ID has 30527 (65.8%) missing values | Missing |
IDENTIDADE_GENERO_ID has 30527 (65.8%) missing values | Missing |
Reproduction
| Analysis started | 2025-05-21 19:38:16.667983 |
|---|---|
| Analysis finished | 2025-05-21 19:38:24.151223 |
| Duration | 7.48 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
ATIVO
Categorical
High correlation Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 362.7 KiB |
| ATIVO | |
|---|---|
| 0 | 8 |
| SELECT CASE WHEN det.ativo = 1 THEN 'ATIVO' ELSE TO_CHAR(det.ativo) END AS ATIVO, pf.PESSOA_FISICA_ID, det.DETENTO_ID as "Prontuário SIAP ?", det.NUMERO_PRONTUARIO, pf.NOME_COMPLETO, pf.DATA_NASCIMENTO, pf.IDADE_ESTIMADA, pf.NACIONALIDADE_ID, pf.NOME_MAE, pf.NOME_PAI, pf.NUMERO_CPF, pf.NUMERO_RG, pf.NUMERO_TEL_CEL, pf.TIPO_DEFICIENCIA_ID, --det.ENDERECO_ID, pf.ESCOLARIDADE_ID, pf.ESTADO_CIVIL_ID, pf.ESTADO_ECONOMICO_ID, pf.PROFISSAO_ID, pf.SEXO_ID, pf.ORIENTACAO_SEXUAL_ID, pf.IDENTIDADE_GENERO_ID, un.sigla FROM siap.detento det JOIN siap.pessoa_fisica pf ON pf.pessoa_fisica_id = det.pessoa_fisica_id JOIN siap.unidade un ON un.unidade_id = det.unidade_id WHERE un.sigla IN ('PATRONATO', 'URA') | 1 |
Length
| Max length | 815 |
|---|---|
| Median length | 5 |
| Mean length | 5.0167651 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SELECT CASE WHEN det.ativo = 1 THEN 'ATIVO' ELSE TO_CHAR(det.ativo) END AS ATIVO, pf.PESSOA_FISICA_ID, det.DETENTO_ID as "Prontuário SIAP ?", det.NUMERO_PRONTUARIO, pf.NOME_COMPLETO, pf.DATA_NASCIMENTO, pf.IDADE_ESTIMADA, pf.NACIONALIDADE_ID, pf.NOME_MAE, pf.NOME_PAI, pf.NUMERO_CPF, pf.NUMERO_RG, pf.NUMERO_TEL_CEL, pf.TIPO_DEFICIENCIA_ID, --det.ENDERECO_ID, pf.ESCOLARIDADE_ID, pf.ESTADO_CIVIL_ID, pf.ESTADO_ECONOMICO_ID, pf.PROFISSAO_ID, pf.SEXO_ID, pf.ORIENTACAO_SEXUAL_ID, pf.IDENTIDADE_GENERO_ID, un.sigla FROM siap.detento det JOIN siap.pessoa_fisica pf ON pf.pessoa_fisica_id = det.pessoa_fisica_id JOIN siap.unidade un ON un.unidade_id = det.unidade_id WHERE un.sigla IN ('PATRONATO', 'URA') |
|---|---|
| 2nd row | ATIVO |
| 3rd row | ATIVO |
| 4th row | ATIVO |
| 5th row | ATIVO |
Common Values
| Value | Count | Frequency (%) |
| ATIVO | 46397 | |
| 0 | 8 | < 0.1% |
| SELECT CASE WHEN det.ativo = 1 THEN 'ATIVO' ELSE TO_CHAR(det.ativo) END AS ATIVO, pf.PESSOA_FISICA_ID, det.DETENTO_ID as "Prontuário SIAP ?", det.NUMERO_PRONTUARIO, pf.NOME_COMPLETO, pf.DATA_NASCIMENTO, pf.IDADE_ESTIMADA, pf.NACIONALIDADE_ID, pf.NOME_MAE, pf.NOME_PAI, pf.NUMERO_CPF, pf.NUMERO_RG, pf.NUMERO_TEL_CEL, pf.TIPO_DEFICIENCIA_ID, --det.ENDERECO_ID, pf.ESCOLARIDADE_ID, pf.ESTADO_CIVIL_ID, pf.ESTADO_ECONOMICO_ID, pf.PROFISSAO_ID, pf.SEXO_ID, pf.ORIENTACAO_SEXUAL_ID, pf.IDENTIDADE_GENERO_ID, un.sigla FROM siap.detento det JOIN siap.pessoa_fisica pf ON pf.pessoa_fisica_id = det.pessoa_fisica_id JOIN siap.unidade un ON un.unidade_id = det.unidade_id WHERE un.sigla IN ('PATRONATO', 'URA') | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ativo | 46399 | |
| 0 | 8 | < 0.1% |
| 4 | < 0.1% | |
| join | 2 | < 0.1% |
| un.sigla | 2 | < 0.1% |
| on | 2 | < 0.1% |
| as | 2 | < 0.1% |
| pf.pessoa_fisica_id | 2 | < 0.1% |
| pf.estado_economico_id | 1 | < 0.1% |
| pf.profissao_id | 1 | < 0.1% |
| Other values (43) | 43 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 46436 | |
| O | 46436 | |
| A | 46430 | |
| T | 46417 | |
| V | 46400 | |
| 144 | 0.1% | |
| E | 45 | < 0.1% |
| _ | 36 | < 0.1% |
| . | 32 | < 0.1% |
| 31 | < 0.1% | |
| Other values (42) | 401 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 232808 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 46436 | |
| O | 46436 | |
| A | 46430 | |
| T | 46417 | |
| V | 46400 | |
| 144 | 0.1% | |
| E | 45 | < 0.1% |
| _ | 36 | < 0.1% |
| . | 32 | < 0.1% |
| 31 | < 0.1% | |
| Other values (42) | 401 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 232808 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 46436 | |
| O | 46436 | |
| A | 46430 | |
| T | 46417 | |
| V | 46400 | |
| 144 | 0.1% | |
| E | 45 | < 0.1% |
| _ | 36 | < 0.1% |
| . | 32 | < 0.1% |
| 31 | < 0.1% | |
| Other values (42) | 401 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 232808 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 46436 | |
| O | 46436 | |
| A | 46430 | |
| T | 46417 | |
| V | 46400 | |
| 144 | 0.1% | |
| E | 45 | < 0.1% |
| _ | 36 | < 0.1% |
| . | 32 | < 0.1% |
| 31 | < 0.1% | |
| Other values (42) | 401 | 0.2% |
PESSOA_FISICA_ID
Real number (ℝ)
High correlation
| Distinct | 46404 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201621.1 |
| Minimum | 25 |
|---|---|
| Maximum | 1034783 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 20070.6 |
| Q1 | 84094 |
| median | 153796 |
| Q3 | 166636 |
| 95-th percentile | 729696.8 |
| Maximum | 1034783 |
| Range | 1034758 |
| Interquartile range (IQR) | 82542 |
Descriptive statistics
| Standard deviation | 206380.25 |
|---|---|
| Coefficient of variation (CV) | 1.0236044 |
| Kurtosis | 3.115907 |
| Mean | 201621.1 |
| Median Absolute Deviation (MAD) | 62045 |
| Skewness | 1.9420307 |
| Sum | 9.3562273 × 109 |
| Variance | 4.2592809 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 85893 | 2 | < 0.1% |
| 163851 | 1 | < 0.1% |
| 163841 | 1 | < 0.1% |
| 163843 | 1 | < 0.1% |
| 163844 | 1 | < 0.1% |
| 163845 | 1 | < 0.1% |
| 163846 | 1 | < 0.1% |
| 163848 | 1 | < 0.1% |
| 163849 | 1 | < 0.1% |
| 163850 | 1 | < 0.1% |
| Other values (46394) | 46394 |
| Value | Count | Frequency (%) |
| 25 | 1 | |
| 34 | 1 | |
| 38 | 1 | |
| 39 | 1 | |
| 40 | 1 | |
| 43 | 1 | |
| 44 | 1 | |
| 45 | 1 | |
| 49 | 1 | |
| 53 | 1 |
| Value | Count | Frequency (%) |
| 1034783 | 1 | |
| 1034765 | 1 | |
| 1034668 | 1 | |
| 1034644 | 1 | |
| 1034583 | 1 | |
| 1034565 | 1 | |
| 1034125 | 1 | |
| 1034105 | 1 | |
| 1034104 | 1 | |
| 1034103 | 1 |
Prontuário SIAP ?
Real number (ℝ)
High correlation
| Distinct | 46405 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141110.71 |
| Minimum | 2 |
|---|---|
| Maximum | 581037 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 18193.4 |
| Q1 | 82192 |
| median | 135872 |
| Q3 | 148726 |
| 95-th percentile | 400675 |
| Maximum | 581037 |
| Range | 581035 |
| Interquartile range (IQR) | 66534 |
Descriptive statistics
| Standard deviation | 104033.95 |
|---|---|
| Coefficient of variation (CV) | 0.73725051 |
| Kurtosis | 3.8832894 |
| Mean | 141110.71 |
| Median Absolute Deviation (MAD) | 39343 |
| Skewness | 1.8426036 |
| Sum | 6.5482426 × 109 |
| Variance | 1.0823062 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 145923 | 1 | < 0.1% |
| 145926 | 1 | < 0.1% |
| 145927 | 1 | < 0.1% |
| 145928 | 1 | < 0.1% |
| 145929 | 1 | < 0.1% |
| 145931 | 1 | < 0.1% |
| 145932 | 1 | < 0.1% |
| 145933 | 1 | < 0.1% |
| 145934 | 1 | < 0.1% |
| 145935 | 1 | < 0.1% |
| Other values (46395) | 46395 |
| Value | Count | Frequency (%) |
| 2 | 1 | |
| 11 | 1 | |
| 15 | 1 | |
| 16 | 1 | |
| 17 | 1 | |
| 20 | 1 | |
| 21 | 1 | |
| 22 | 1 | |
| 26 | 1 | |
| 30 | 1 |
| Value | Count | Frequency (%) |
| 581037 | 1 | |
| 581036 | 1 | |
| 580995 | 1 | |
| 580980 | 1 | |
| 580936 | 1 | |
| 580935 | 1 | |
| 580735 | 1 | |
| 580720 | 1 | |
| 580719 | 1 | |
| 580718 | 1 |
| Distinct | 46389 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.1448988 |
| Min length | 2 |
Unique
| Unique | 46387 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | 4005332 |
|---|---|
| 2nd row | 4005369 |
| 3rd row | 4005380 |
| 4th row | 4005439 |
| 5th row | 4005446 |
| Value | Count | Frequency (%) |
| 2012187 | 2 | < 0.1% |
| 4002340 | 2 | < 0.1% |
| 2037116 | 1 | < 0.1% |
| 4009477 | 1 | < 0.1% |
| 4005730 | 1 | < 0.1% |
| 4005723 | 1 | < 0.1% |
| 4005523 | 1 | < 0.1% |
| 4005369 | 1 | < 0.1% |
| 4005380 | 1 | < 0.1% |
| 4005439 | 1 | < 0.1% |
| Other values (46379) | 46379 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 86303 | |
| 2 | 50042 | |
| 1 | 36370 | |
| 3 | 24979 | 7.5% |
| 4 | 24637 | 7.4% |
| 5 | 24159 | 7.3% |
| 7 | 23695 | 7.1% |
| 6 | 22874 | 6.9% |
| 8 | 20579 | 6.2% |
| 9 | 17770 | 5.4% |
| Other values (3) | 51 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 331459 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86303 | |
| 2 | 50042 | |
| 1 | 36370 | |
| 3 | 24979 | 7.5% |
| 4 | 24637 | 7.4% |
| 5 | 24159 | 7.3% |
| 7 | 23695 | 7.1% |
| 6 | 22874 | 6.9% |
| 8 | 20579 | 6.2% |
| 9 | 17770 | 5.4% |
| Other values (3) | 51 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 331459 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86303 | |
| 2 | 50042 | |
| 1 | 36370 | |
| 3 | 24979 | 7.5% |
| 4 | 24637 | 7.4% |
| 5 | 24159 | 7.3% |
| 7 | 23695 | 7.1% |
| 6 | 22874 | 6.9% |
| 8 | 20579 | 6.2% |
| 9 | 17770 | 5.4% |
| Other values (3) | 51 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 331459 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86303 | |
| 2 | 50042 | |
| 1 | 36370 | |
| 3 | 24979 | 7.5% |
| 4 | 24637 | 7.4% |
| 5 | 24159 | 7.3% |
| 7 | 23695 | 7.1% |
| 6 | 22874 | 6.9% |
| 8 | 20579 | 6.2% |
| 9 | 17770 | 5.4% |
| Other values (3) | 51 | < 0.1% |
NOME_COMPLETO
Text
| Distinct | 43177 |
|---|---|
| Distinct (%) | 93.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
Length
| Max length | 100 |
|---|---|
| Median length | 92 |
| Mean length | 26.323995 |
| Min length | 5 |
Unique
| Unique | 41527 ? |
|---|---|
| Unique (%) | 89.5% |
Sample
| 1st row | MARIA LÚCIA IRACI NASCIMENTO DE LIMA |
|---|---|
| 2nd row | MARIA DA CONCEIÇÃO DOS SANTOS |
| 3rd row | GILVÂNIA MELQUÍADES DA SILVA |
| 4th row | ERICA IRIS DE SANTANA ALBUQUERQUE |
| 5th row | MAIZA SEVERINA DA SILVA |
| Value | Count | Frequency (%) |
| silva | 21257 | 10.7% |
| da | 20312 | 10.2% |
| de | 12381 | 6.2% |
| jose | 7232 | 3.6% |
| santos | 5699 | 2.9% |
| dos | 4560 | 2.3% |
| lima | 2629 | 1.3% |
| oliveira | 2534 | 1.3% |
| ferreira | 2330 | 1.2% |
| souza | 2229 | 1.1% |
| Other values (9527) | 118038 |
Most occurring characters
| Value | Count | Frequency (%) |
| 152995 | ||
| A | 152560 | |
| O | 109675 | |
| E | 101691 | |
| I | 95549 | |
| S | 95359 | |
| R | 75086 | 6.1% |
| L | 71383 | 5.8% |
| D | 66827 | 5.5% |
| N | 63396 | 5.2% |
| Other values (86) | 237044 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1221565 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 152995 | ||
| A | 152560 | |
| O | 109675 | |
| E | 101691 | |
| I | 95549 | |
| S | 95359 | |
| R | 75086 | 6.1% |
| L | 71383 | 5.8% |
| D | 66827 | 5.5% |
| N | 63396 | 5.2% |
| Other values (86) | 237044 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1221565 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 152995 | ||
| A | 152560 | |
| O | 109675 | |
| E | 101691 | |
| I | 95549 | |
| S | 95359 | |
| R | 75086 | 6.1% |
| L | 71383 | 5.8% |
| D | 66827 | 5.5% |
| N | 63396 | 5.2% |
| Other values (86) | 237044 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1221565 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 152995 | ||
| A | 152560 | |
| O | 109675 | |
| E | 101691 | |
| I | 95549 | |
| S | 95359 | |
| R | 75086 | 6.1% |
| L | 71383 | 5.8% |
| D | 66827 | 5.5% |
| N | 63396 | 5.2% |
| Other values (86) | 237044 |
DATA_NASCIMENTO
Date
| Distinct | 14792 |
|---|---|
| Distinct (%) | 31.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
| Minimum | 1899-12-30 00:00:00 |
|---|---|
| Maximum | 2006-04-04 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
IDADE_ESTIMADA
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 45227 |
| Missing (%) | 97.5% |
| Memory size | 362.7 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1179 | 2.5% |
| (Missing) | 45227 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1179 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2358 | |
| . | 1179 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3537 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2358 | |
| . | 1179 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3537 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2358 | |
| . | 1179 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3537 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2358 | |
| . | 1179 |
NACIONALIDADE_ID
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 80 |
| Missing (%) | 0.2% |
| Memory size | 362.7 KiB |
| 1.0 | |
|---|---|
| 4.0 | 68 |
| 3.0 | 67 |
| 2.0 | 2 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 46189 | |
| 4.0 | 68 | 0.1% |
| 3.0 | 67 | 0.1% |
| 2.0 | 2 | < 0.1% |
| (Missing) | 80 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 46189 | |
| 4.0 | 68 | 0.1% |
| 3.0 | 67 | 0.1% |
| 2.0 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 46326 | |
| 0 | 46326 | |
| 1 | 46189 | |
| 4 | 68 | < 0.1% |
| 3 | 67 | < 0.1% |
| 2 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 138978 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 46326 | |
| 0 | 46326 | |
| 1 | 46189 | |
| 4 | 68 | < 0.1% |
| 3 | 67 | < 0.1% |
| 2 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 138978 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 46326 | |
| 0 | 46326 | |
| 1 | 46189 | |
| 4 | 68 | < 0.1% |
| 3 | 67 | < 0.1% |
| 2 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 138978 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 46326 | |
| 0 | 46326 | |
| 1 | 46189 | |
| 4 | 68 | < 0.1% |
| 3 | 67 | < 0.1% |
| 2 | 2 | < 0.1% |
NOME_MAE
Text
| Distinct | 36591 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
Length
| Max length | 99 |
|---|---|
| Median length | 82 |
| Mean length | 25.66732 |
| Min length | 1 |
Unique
| Unique | 33295 ? |
|---|---|
| Unique (%) | 71.7% |
Sample
| 1st row | SEVERINA IRACI DO NASCIMENTO |
|---|---|
| 2nd row | MARIA FILOMENA DOS SANTOS |
| 3rd row | GENILDA ALVES DA SILVA |
| 4th row | MARTA MARIA DE SANTANA |
| 5th row | SEVERINA MARIA DA SILVA |
| Value | Count | Frequency (%) |
| maria | 22847 | 11.5% |
| da | 22139 | 11.1% |
| silva | 19291 | 9.7% |
| de | 13227 | 6.7% |
| santos | 5001 | 2.5% |
| dos | 4397 | 2.2% |
| do | 3128 | 1.6% |
| jose | 2444 | 1.2% |
| lima | 2339 | 1.2% |
| oliveira | 2174 | 1.1% |
| Other values (7671) | 101804 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 205179 | |
| 152898 | ||
| I | 114198 | |
| E | 98309 | |
| R | 81627 | 6.9% |
| S | 77099 | 6.5% |
| O | 65699 | 5.5% |
| D | 63323 | 5.3% |
| L | 56429 | 4.7% |
| N | 52839 | 4.4% |
| Other values (72) | 223492 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1191092 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 205179 | |
| 152898 | ||
| I | 114198 | |
| E | 98309 | |
| R | 81627 | 6.9% |
| S | 77099 | 6.5% |
| O | 65699 | 5.5% |
| D | 63323 | 5.3% |
| L | 56429 | 4.7% |
| N | 52839 | 4.4% |
| Other values (72) | 223492 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1191092 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 205179 | |
| 152898 | ||
| I | 114198 | |
| E | 98309 | |
| R | 81627 | 6.9% |
| S | 77099 | 6.5% |
| O | 65699 | 5.5% |
| D | 63323 | 5.3% |
| L | 56429 | 4.7% |
| N | 52839 | 4.4% |
| Other values (72) | 223492 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1191092 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 205179 | |
| 152898 | ||
| I | 114198 | |
| E | 98309 | |
| R | 81627 | 6.9% |
| S | 77099 | 6.5% |
| O | 65699 | 5.5% |
| D | 63323 | 5.3% |
| L | 56429 | 4.7% |
| N | 52839 | 4.4% |
| Other values (72) | 223492 |
NOME_PAI
Text
| Distinct | 32851 |
|---|---|
| Distinct (%) | 70.8% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
Length
| Max length | 90 |
|---|---|
| Median length | 71 |
| Mean length | 22.942591 |
| Min length | 1 |
Unique
| Unique | 29627 ? |
|---|---|
| Unique (%) | 63.8% |
Sample
| 1st row | JOÃO LÚCIO SOBRINHO |
|---|---|
| 2nd row | 0 |
| 3rd row | JOSÉ MELQUÍADES DA SILVA |
| 4th row | ROBERTO KENNEDY DE ALBUQUERQUE |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| da | 16461 | 9.6% |
| silva | 15958 | 9.3% |
| de | 10541 | 6.1% |
| jose | 9803 | 5.7% |
| declarado | 4859 | 2.8% |
| santos | 3912 | 2.3% |
| dos | 3749 | 2.2% |
| antonio | 3242 | 1.9% |
| severino | 2785 | 1.6% |
| manoel | 2291 | 1.3% |
| Other values (5891) | 98555 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 126607 | |
| 126231 | ||
| O | 108570 | |
| E | 86483 | 8.1% |
| I | 78777 | 7.4% |
| S | 76781 | 7.2% |
| D | 62634 | 5.9% |
| R | 61086 | 5.7% |
| L | 56523 | 5.3% |
| N | 55724 | 5.2% |
| Other values (72) | 225212 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1064628 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 126607 | |
| 126231 | ||
| O | 108570 | |
| E | 86483 | 8.1% |
| I | 78777 | 7.4% |
| S | 76781 | 7.2% |
| D | 62634 | 5.9% |
| R | 61086 | 5.7% |
| L | 56523 | 5.3% |
| N | 55724 | 5.2% |
| Other values (72) | 225212 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1064628 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 126607 | |
| 126231 | ||
| O | 108570 | |
| E | 86483 | 8.1% |
| I | 78777 | 7.4% |
| S | 76781 | 7.2% |
| D | 62634 | 5.9% |
| R | 61086 | 5.7% |
| L | 56523 | 5.3% |
| N | 55724 | 5.2% |
| Other values (72) | 225212 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1064628 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 126607 | |
| 126231 | ||
| O | 108570 | |
| E | 86483 | 8.1% |
| I | 78777 | 7.4% |
| S | 76781 | 7.2% |
| D | 62634 | 5.9% |
| R | 61086 | 5.7% |
| L | 56523 | 5.3% |
| N | 55724 | 5.2% |
| Other values (72) | 225212 |
NUMERO_CPF
Text
Missing
| Distinct | 11476 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 34913 |
| Missing (%) | 75.2% |
| Memory size | 362.7 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 12.163317 |
| Min length | 3 |
Unique
| Unique | 11459 ? |
|---|---|
| Unique (%) | 99.7% |
Sample
| 1st row | 07896490471 |
|---|---|
| 2nd row | 09163294451 |
| 3rd row | 49251872449 |
| 4th row | 45038945449 |
| 5th row | 71244383490 |
| Value | Count | Frequency (%) |
| 702.296.844-67 | 2 | < 0.1% |
| 10005354447 | 2 | < 0.1% |
| 07236692441 | 2 | < 0.1% |
| 052.040.014-33 | 2 | < 0.1% |
| 70339614480 | 2 | < 0.1% |
| informado | 2 | < 0.1% |
| 70257097430 | 2 | < 0.1% |
| 088.231.754-70 | 2 | < 0.1% |
| 11460014448 | 2 | < 0.1% |
| nao | 2 | < 0.1% |
| Other values (11475) | 11483 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 20951 | |
| 0 | 18813 | |
| 1 | 13380 | |
| 7 | 11667 | |
| 8 | 10747 | |
| 3 | 10326 | |
| 9 | 10289 | |
| 2 | 10200 | |
| 5 | 9972 | |
| 6 | 9947 | |
| Other values (19) | 13501 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 139793 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 20951 | |
| 0 | 18813 | |
| 1 | 13380 | |
| 7 | 11667 | |
| 8 | 10747 | |
| 3 | 10326 | |
| 9 | 10289 | |
| 2 | 10200 | |
| 5 | 9972 | |
| 6 | 9947 | |
| Other values (19) | 13501 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 139793 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 20951 | |
| 0 | 18813 | |
| 1 | 13380 | |
| 7 | 11667 | |
| 8 | 10747 | |
| 3 | 10326 | |
| 9 | 10289 | |
| 2 | 10200 | |
| 5 | 9972 | |
| 6 | 9947 | |
| Other values (19) | 13501 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 139793 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 20951 | |
| 0 | 18813 | |
| 1 | 13380 | |
| 7 | 11667 | |
| 8 | 10747 | |
| 3 | 10326 | |
| 9 | 10289 | |
| 2 | 10200 | |
| 5 | 9972 | |
| 6 | 9947 | |
| Other values (19) | 13501 |
NUMERO_RG
Text
Missing
| Distinct | 10372 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 36031 |
| Missing (%) | 77.6% |
| Memory size | 362.7 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 7 |
| Mean length | 7.3290602 |
| Min length | 5 |
Unique
| Unique | 10369 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | 7601520 |
|---|---|
| 2nd row | 8326972 |
| 3rd row | 2762058 |
| 4th row | 2014180 |
| 5th row | 5971232 |
| Value | Count | Frequency (%) |
| 6389951 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 2 | 2 | < 0.1% |
| 8 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 7472209 | 2 | < 0.1% |
| 10429524 | 2 | < 0.1% |
| 7753668 | 1 | < 0.1% |
| 7965967 | 1 | < 0.1% |
| 8995247 | 1 | < 0.1% |
| Other values (10378) | 10378 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 8581 | |
| 8 | 8270 | |
| 1 | 7993 | |
| 7 | 7989 | |
| 0 | 7758 | |
| 6 | 7290 | |
| 3 | 6869 | |
| 5 | 6862 | |
| 4 | 6845 | |
| 2 | 6431 | |
| Other values (12) | 1151 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 76039 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 8581 | |
| 8 | 8270 | |
| 1 | 7993 | |
| 7 | 7989 | |
| 0 | 7758 | |
| 6 | 7290 | |
| 3 | 6869 | |
| 5 | 6862 | |
| 4 | 6845 | |
| 2 | 6431 | |
| Other values (12) | 1151 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 76039 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 8581 | |
| 8 | 8270 | |
| 1 | 7993 | |
| 7 | 7989 | |
| 0 | 7758 | |
| 6 | 7290 | |
| 3 | 6869 | |
| 5 | 6862 | |
| 4 | 6845 | |
| 2 | 6431 | |
| Other values (12) | 1151 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 76039 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 8581 | |
| 8 | 8270 | |
| 1 | 7993 | |
| 7 | 7989 | |
| 0 | 7758 | |
| 6 | 7290 | |
| 3 | 6869 | |
| 5 | 6862 | |
| 4 | 6845 | |
| 2 | 6431 | |
| Other values (12) | 1151 | 1.5% |
NUMERO_TEL_CEL
Real number (ℝ)
High correlation Missing
| Distinct | 7423 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 38959 |
| Missing (%) | 84.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9008873 × 1010 |
| Minimum | 0 |
|---|---|
| Maximum | 9.9993917 × 1010 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.1969294 × 1010 |
| Q1 | 8.1984674 × 1010 |
| median | 8.1987351 × 1010 |
| Q3 | 8.1993028 × 1010 |
| 95-th percentile | 8.199997 × 1010 |
| Maximum | 9.9993917 × 1010 |
| Range | 9.9993917 × 1010 |
| Interquartile range (IQR) | 8354464.5 |
Descriptive statistics
| Standard deviation | 1.5127779 × 1010 |
|---|---|
| Coefficient of variation (CV) | 0.19146936 |
| Kurtosis | 17.574574 |
| Mean | 7.9008873 × 1010 |
| Median Absolute Deviation (MAD) | 3321558 |
| Skewness | -4.3937554 |
| Sum | 5.8837907 × 1014 |
| Variance | 2.2884968 × 1020 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8.198615329 × 1010 | 2 | < 0.1% |
| 8.198832172 × 1010 | 2 | < 0.1% |
| 8.198619585 × 1010 | 2 | < 0.1% |
| 8.198768052 × 1010 | 2 | < 0.1% |
| 8.19867753 × 1010 | 2 | < 0.1% |
| 8.198734554 × 1010 | 2 | < 0.1% |
| 8.198899773 × 1010 | 2 | < 0.1% |
| 8.198674202 × 1010 | 2 | < 0.1% |
| 8.198588352 × 1010 | 2 | < 0.1% |
| 8.19885314 × 1010 | 2 | < 0.1% |
| Other values (7413) | 7427 | 16.0% |
| (Missing) | 38959 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 8 | 1 | |
| 1986382385 | 1 | |
| 1988183302 | 1 | |
| 6282662787 | 1 | |
| 7193665152 | 1 | |
| 7491511820 | 1 | |
| 8130385010 | 1 | |
| 8130917726 | 1 | |
| 8132221400 | 1 |
| Value | Count | Frequency (%) |
| 9.99939173 × 1010 | 1 | |
| 9.81963979 × 1010 | 1 | |
| 9.599140384 × 1010 | 1 | |
| 9.198877999 × 1010 | 1 | |
| 9.198461025 × 1010 | 1 | |
| 9.198437924 × 1010 | 1 | |
| 9.198323732 × 1010 | 1 | |
| 8.999436332 × 1010 | 1 | |
| 8.999413606 × 1010 | 1 | |
| 8.999403733 × 1010 | 1 |
TIPO_DEFICIENCIA_ID
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.6226269 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 6 |
| Q3 | 6 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.52288878 |
|---|---|
| Coefficient of variation (CV) | 0.09299724 |
| Kurtosis | 3.7690055 |
| Mean | 5.6226269 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.2961445 |
| Sum | 260918 |
| Variance | 0.27341268 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 6 | 29446 | |
| 5 | 16671 | |
| 3 | 174 | 0.4% |
| 4 | 78 | 0.2% |
| 1 | 19 | < 0.1% |
| 2 | 17 | < 0.1% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 19 | < 0.1% |
| 2 | 17 | < 0.1% |
| 3 | 174 | 0.4% |
| 4 | 78 | 0.2% |
| 5 | 16671 | |
| 6 | 29446 |
| Value | Count | Frequency (%) |
| 6 | 29446 | |
| 5 | 16671 | |
| 4 | 78 | 0.2% |
| 3 | 174 | 0.4% |
| 2 | 17 | < 0.1% |
| 1 | 19 | < 0.1% |
ESCOLARIDADE_ID
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 13 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9455521 |
| Minimum | 1 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 15 |
| Range | 14 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.7124606 |
|---|---|
| Coefficient of variation (CV) | 0.687473 |
| Kurtosis | 6.4876408 |
| Mean | 3.9455521 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.404962 |
| Sum | 183046 |
| Variance | 7.3574423 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 3 | 22277 | |
| 5 | 5772 | 12.4% |
| 6 | 4849 | 10.4% |
| 1 | 4606 | 9.9% |
| 2 | 3830 | 8.3% |
| 14 | 2235 | 4.8% |
| 4 | 1876 | 4.0% |
| 7 | 571 | 1.2% |
| 8 | 328 | 0.7% |
| 15 | 20 | < 0.1% |
| Other values (3) | 29 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4606 | 9.9% |
| 2 | 3830 | 8.3% |
| 3 | 22277 | |
| 4 | 1876 | 4.0% |
| 5 | 5772 | 12.4% |
| 6 | 4849 | 10.4% |
| 7 | 571 | 1.2% |
| 8 | 328 | 0.7% |
| 9 | 12 | < 0.1% |
| 10 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 20 | < 0.1% |
| 14 | 2235 | 4.8% |
| 11 | 2 | < 0.1% |
| 10 | 15 | < 0.1% |
| 9 | 12 | < 0.1% |
| 8 | 328 | 0.7% |
| 7 | 571 | 1.2% |
| 6 | 4849 | |
| 5 | 5772 | |
| 4 | 1876 | 4.0% |
ESTADO_CIVIL_ID
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2321086 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.3822716 |
|---|---|
| Coefficient of variation (CV) | 0.32661535 |
| Kurtosis | 1.9722397 |
| Mean | 4.2321086 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.55530826 |
| Sum | 196391 |
| Variance | 1.9106749 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 4 | 21220 | |
| 5 | 16978 | |
| 1 | 4625 | 10.0% |
| 7 | 2255 | 4.9% |
| 2 | 578 | 1.2% |
| 9 | 347 | 0.7% |
| 6 | 217 | 0.5% |
| 3 | 170 | 0.4% |
| 8 | 15 | < 0.1% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4625 | 10.0% |
| 2 | 578 | 1.2% |
| 3 | 170 | 0.4% |
| 4 | 21220 | |
| 5 | 16978 | |
| 6 | 217 | 0.5% |
| 7 | 2255 | 4.9% |
| 8 | 15 | < 0.1% |
| 9 | 347 | 0.7% |
| Value | Count | Frequency (%) |
| 9 | 347 | 0.7% |
| 8 | 15 | < 0.1% |
| 7 | 2255 | 4.9% |
| 6 | 217 | 0.5% |
| 5 | 16978 | |
| 4 | 21220 | |
| 3 | 170 | 0.4% |
| 2 | 578 | 1.2% |
| 1 | 4625 | 10.0% |
ESTADO_ECONOMICO_ID
Real number (ℝ)
Missing
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8427 |
| Missing (%) | 18.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4800284 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.2670201 |
|---|---|
| Coefficient of variation (CV) | 0.51088935 |
| Kurtosis | 15.096385 |
| Mean | 2.4800284 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.5296551 |
| Sum | 94189 |
| Variance | 1.60534 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 2 | 24242 | |
| 3 | 8303 | 17.9% |
| 1 | 2093 | 4.5% |
| 4 | 1942 | 4.2% |
| 9 | 932 | 2.0% |
| 5 | 314 | 0.7% |
| 6 | 120 | 0.3% |
| 7 | 17 | < 0.1% |
| 8 | 11 | < 0.1% |
| 10 | 5 | < 0.1% |
| (Missing) | 8427 | 18.2% |
| Value | Count | Frequency (%) |
| 1 | 2093 | 4.5% |
| 2 | 24242 | |
| 3 | 8303 | 17.9% |
| 4 | 1942 | 4.2% |
| 5 | 314 | 0.7% |
| 6 | 120 | 0.3% |
| 7 | 17 | < 0.1% |
| 8 | 11 | < 0.1% |
| 9 | 932 | 2.0% |
| 10 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 5 | < 0.1% |
| 9 | 932 | 2.0% |
| 8 | 11 | < 0.1% |
| 7 | 17 | < 0.1% |
| 6 | 120 | 0.3% |
| 5 | 314 | 0.7% |
| 4 | 1942 | 4.2% |
| 3 | 8303 | 17.9% |
| 2 | 24242 | |
| 1 | 2093 | 4.5% |
PROFISSAO_ID
Real number (ℝ)
Missing
| Distinct | 578 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 25667 |
| Missing (%) | 55.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 416.87159 |
| Minimum | 1 |
|---|---|
| Maximum | 926 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 362.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 51 |
| Q1 | 157 |
| median | 405 |
| Q3 | 638 |
| 95-th percentile | 817 |
| Maximum | 926 |
| Range | 925 |
| Interquartile range (IQR) | 481 |
Descriptive statistics
| Standard deviation | 260.78058 |
|---|---|
| Coefficient of variation (CV) | 0.62556572 |
| Kurtosis | -1.3667134 |
| Mean | 416.87159 |
| Median Absolute Deviation (MAD) | 246 |
| Skewness | -0.030712045 |
| Sum | 8645500 |
| Variance | 68006.51 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 73 | 1411 | 3.0% |
| 638 | 923 | 2.0% |
| 157 | 884 | 1.9% |
| 594 | 856 | 1.8% |
| 6 | 855 | 1.8% |
| 346 | 839 | 1.8% |
| 99 | 782 | 1.7% |
| 738 | 672 | 1.4% |
| 731 | 616 | 1.3% |
| 581 | 552 | 1.2% |
| Other values (568) | 12349 | |
| (Missing) | 25667 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 8 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 28 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 855 | |
| 26 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 28 | 24 | 0.1% |
| 30 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 926 | 70 | |
| 886 | 1 | < 0.1% |
| 866 | 101 | |
| 858 | 52 | 0.1% |
| 857 | 3 | < 0.1% |
| 855 | 1 | < 0.1% |
| 852 | 2 | < 0.1% |
| 851 | 132 | |
| 850 | 13 | < 0.1% |
| 848 | 28 | 0.1% |
SEXO_ID
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
| 1.0 | |
|---|---|
| 2.0 | 2636 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 2.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 43769 | |
| 2.0 | 2636 | 5.7% |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 43769 | |
| 2.0 | 2636 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 46405 | |
| 0 | 46405 | |
| 1 | 43769 | |
| 2 | 2636 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 139215 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 46405 | |
| 0 | 46405 | |
| 1 | 43769 | |
| 2 | 2636 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 139215 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 46405 | |
| 0 | 46405 | |
| 1 | 43769 | |
| 2 | 2636 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 139215 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 46405 | |
| 0 | 46405 | |
| 1 | 43769 | |
| 2 | 2636 | 1.9% |
ORIENTACAO_SEXUAL_ID
Categorical
High correlation Imbalance Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30527 |
| Missing (%) | 65.8% |
| Memory size | 362.7 KiB |
| 26.0 | |
|---|---|
| 29.0 | 162 |
| 28.0 | 95 |
| 27.0 | 92 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 26.0 |
|---|---|
| 2nd row | 26.0 |
| 3rd row | 26.0 |
| 4th row | 29.0 |
| 5th row | 26.0 |
Common Values
| Value | Count | Frequency (%) |
| 26.0 | 15530 | |
| 29.0 | 162 | 0.3% |
| 28.0 | 95 | 0.2% |
| 27.0 | 92 | 0.2% |
| (Missing) | 30527 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 26.0 | 15530 | |
| 29.0 | 162 | 1.0% |
| 28.0 | 95 | 0.6% |
| 27.0 | 92 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15530 | |
| 9 | 162 | 0.3% |
| 8 | 95 | 0.1% |
| 7 | 92 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15530 | |
| 9 | 162 | 0.3% |
| 8 | 95 | 0.1% |
| 7 | 92 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15530 | |
| 9 | 162 | 0.3% |
| 8 | 95 | 0.1% |
| 7 | 92 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15530 | |
| 9 | 162 | 0.3% |
| 8 | 95 | 0.1% |
| 7 | 92 | 0.1% |
IDENTIDADE_GENERO_ID
Categorical
High correlation Imbalance Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30527 |
| Missing (%) | 65.8% |
| Memory size | 362.7 KiB |
| 26.0 | |
|---|---|
| 29.0 | 53 |
| 28.0 | 34 |
| 27.0 | 24 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 26.0 |
|---|---|
| 2nd row | 26.0 |
| 3rd row | 26.0 |
| 4th row | 26.0 |
| 5th row | 26.0 |
Common Values
| Value | Count | Frequency (%) |
| 26.0 | 15768 | |
| 29.0 | 53 | 0.1% |
| 28.0 | 34 | 0.1% |
| 27.0 | 24 | 0.1% |
| (Missing) | 30527 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 26.0 | 15768 | |
| 29.0 | 53 | 0.3% |
| 28.0 | 34 | 0.2% |
| 27.0 | 24 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15768 | |
| 9 | 53 | 0.1% |
| 8 | 34 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15768 | |
| 9 | 53 | 0.1% |
| 8 | 34 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15768 | |
| 9 | 53 | 0.1% |
| 8 | 34 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 63516 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15879 | |
| . | 15879 | |
| 0 | 15879 | |
| 6 | 15768 | |
| 9 | 53 | 0.1% |
| 8 | 34 | 0.1% |
| 7 | 24 | < 0.1% |
SIGLA
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 362.7 KiB |
| URA | |
|---|---|
| PATRONATO |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 5.9058076 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | URA |
|---|---|
| 2nd row | URA |
| 3rd row | PATRONATO |
| 4th row | PATRONATO |
| 5th row | PATRONATO |
Common Values
| Value | Count | Frequency (%) |
| URA | 23931 | |
| PATRONATO | 22474 | |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ura | 23931 | |
| patronato | 22474 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 68879 | |
| R | 46405 | |
| T | 44948 | |
| O | 44948 | |
| U | 23931 | 8.7% |
| P | 22474 | 8.2% |
| N | 22474 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 274059 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 68879 | |
| R | 46405 | |
| T | 44948 | |
| O | 44948 | |
| U | 23931 | 8.7% |
| P | 22474 | 8.2% |
| N | 22474 | 8.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 274059 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 68879 | |
| R | 46405 | |
| T | 44948 | |
| O | 44948 | |
| U | 23931 | 8.7% |
| P | 22474 | 8.2% |
| N | 22474 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 274059 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 68879 | |
| R | 46405 | |
| T | 44948 | |
| O | 44948 | |
| U | 23931 | 8.7% |
| P | 22474 | 8.2% |
| N | 22474 | 8.2% |
Interactions
Correlations
| ATIVO | ESCOLARIDADE_ID | ESTADO_CIVIL_ID | ESTADO_ECONOMICO_ID | IDENTIDADE_GENERO_ID | NACIONALIDADE_ID | NUMERO_TEL_CEL | ORIENTACAO_SEXUAL_ID | PESSOA_FISICA_ID | PROFISSAO_ID | Prontuário SIAP ? | SEXO_ID | SIGLA | TIPO_DEFICIENCIA_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATIVO | 1.000 | 0.000 | 0.000 | 0.017 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.041 | 0.000 | 0.000 | 0.010 | 0.000 |
| ESCOLARIDADE_ID | 0.000 | 1.000 | 0.101 | 0.116 | 0.000 | 0.035 | 0.038 | 0.010 | 0.115 | 0.057 | 0.115 | 0.070 | 0.235 | -0.059 |
| ESTADO_CIVIL_ID | 0.000 | 0.101 | 1.000 | -0.061 | 0.027 | 0.023 | -0.037 | 0.042 | -0.094 | 0.029 | -0.094 | 0.142 | 0.171 | 0.037 |
| ESTADO_ECONOMICO_ID | 0.017 | 0.116 | -0.061 | 1.000 | 0.000 | 0.032 | -0.020 | 0.062 | 0.024 | 0.073 | 0.024 | 0.176 | 0.182 | 0.273 |
| IDENTIDADE_GENERO_ID | 1.000 | 0.000 | 0.027 | 0.000 | 1.000 | 0.000 | 0.081 | 0.363 | 0.020 | 0.035 | 0.019 | 0.091 | 0.022 | 0.017 |
| NACIONALIDADE_ID | 0.000 | 0.035 | 0.023 | 0.032 | 0.000 | 1.000 | 0.000 | 0.000 | 0.027 | 0.000 | 0.031 | 0.027 | 0.036 | 0.018 |
| NUMERO_TEL_CEL | 1.000 | 0.038 | -0.037 | -0.020 | 0.081 | 0.000 | 1.000 | 0.000 | 0.094 | -0.026 | 0.095 | 0.034 | 0.122 | -0.074 |
| ORIENTACAO_SEXUAL_ID | 1.000 | 0.010 | 0.042 | 0.062 | 0.363 | 0.000 | 0.000 | 1.000 | 0.022 | 0.073 | 0.070 | 0.428 | 0.048 | 0.014 |
| PESSOA_FISICA_ID | 0.000 | 0.115 | -0.094 | 0.024 | 0.020 | 0.027 | 0.094 | 0.022 | 1.000 | 0.140 | 1.000 | 0.072 | 0.451 | -0.233 |
| PROFISSAO_ID | 0.041 | 0.057 | 0.029 | 0.073 | 0.035 | 0.000 | -0.026 | 0.073 | 0.140 | 1.000 | 0.140 | 0.347 | 0.272 | -0.120 |
| Prontuário SIAP ? | 0.000 | 0.115 | -0.094 | 0.024 | 0.019 | 0.031 | 0.095 | 0.070 | 1.000 | 0.140 | 1.000 | 0.249 | 0.449 | -0.232 |
| SEXO_ID | 0.000 | 0.070 | 0.142 | 0.176 | 0.091 | 0.027 | 0.034 | 0.428 | 0.072 | 0.347 | 0.249 | 1.000 | 0.051 | 0.000 |
| SIGLA | 0.010 | 0.235 | 0.171 | 0.182 | 0.022 | 0.036 | 0.122 | 0.048 | 0.451 | 0.272 | 0.449 | 0.051 | 1.000 | 0.333 |
| TIPO_DEFICIENCIA_ID | 0.000 | -0.059 | 0.037 | 0.273 | 0.017 | 0.018 | -0.074 | 0.014 | -0.233 | -0.120 | -0.232 | 0.000 | 0.333 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| ATIVO | PESSOA_FISICA_ID | Prontuário SIAP ? | NUMERO_PRONTUARIO | NOME_COMPLETO | DATA_NASCIMENTO | IDADE_ESTIMADA | NACIONALIDADE_ID | NOME_MAE | NOME_PAI | NUMERO_CPF | NUMERO_RG | NUMERO_TEL_CEL | TIPO_DEFICIENCIA_ID | ESCOLARIDADE_ID | ESTADO_CIVIL_ID | ESTADO_ECONOMICO_ID | PROFISSAO_ID | SEXO_ID | ORIENTACAO_SEXUAL_ID | IDENTIDADE_GENERO_ID | SIGLA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SELECT \n CASE \n WHEN det.ativo = 1 THEN 'ATIVO'\n ELSE TO_CHAR(det.ativo)\n END AS ATIVO,\n pf.PESSOA_FISICA_ID,\n det.DETENTO_ID as "Prontuário SIAP ?",\n det.NUMERO_PRONTUARIO,\n pf.NOME_COMPLETO,\n pf.DATA_NASCIMENTO,\n pf.IDADE_ESTIMADA,\n pf.NACIONALIDADE_ID,\n pf.NOME_MAE,\n pf.NOME_PAI,\n pf.NUMERO_CPF,\n pf.NUMERO_RG,\n pf.NUMERO_TEL_CEL,\n pf.TIPO_DEFICIENCIA_ID,\n --det.ENDERECO_ID,\n pf.ESCOLARIDADE_ID,\n pf.ESTADO_CIVIL_ID,\n pf.ESTADO_ECONOMICO_ID,\n pf.PROFISSAO_ID,\n pf.SEXO_ID,\n pf.ORIENTACAO_SEXUAL_ID,\n pf.IDENTIDADE_GENERO_ID,\n un.sigla\n\nFROM siap.detento det\nJOIN siap.pessoa_fisica pf ON pf.pessoa_fisica_id = det.pessoa_fisica_id\nJOIN siap.unidade un ON un.unidade_id = det.unidade_id\nWHERE un.sigla IN ('PATRONATO', 'URA') | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | ATIVO | 168.0 | 145.0 | 4005332 | MARIA LÚCIA IRACI NASCIMENTO DE LIMA | 1987-04-01 00:00:00 | 0.0 | 1.0 | SEVERINA IRACI DO NASCIMENTO | JOÃO LÚCIO SOBRINHO | NaN | NaN | NaN | 6.0 | 4.0 | 1.0 | 2.0 | 6.0 | 2.0 | NaN | NaN | URA |
| 2 | ATIVO | 171.0 | 148.0 | 4005369 | MARIA DA CONCEIÇÃO DOS SANTOS | 1987-10-25 01:00:00 | 0.0 | 1.0 | MARIA FILOMENA DOS SANTOS | 0 | NaN | NaN | NaN | 6.0 | 2.0 | 5.0 | NaN | 6.0 | 2.0 | NaN | NaN | URA |
| 3 | ATIVO | 173.0 | 150.0 | 4005380 | GILVÂNIA MELQUÍADES DA SILVA | 1986-06-05 00:00:00 | 0.0 | 1.0 | GENILDA ALVES DA SILVA | JOSÉ MELQUÍADES DA SILVA | NaN | NaN | NaN | 6.0 | 6.0 | 4.0 | 2.0 | 6.0 | 2.0 | NaN | NaN | PATRONATO |
| 4 | ATIVO | 179.0 | 156.0 | 4005439 | ERICA IRIS DE SANTANA ALBUQUERQUE | 1985-01-27 00:00:00 | 0.0 | 1.0 | MARTA MARIA DE SANTANA | ROBERTO KENNEDY DE ALBUQUERQUE | NaN | NaN | 8.198520e+10 | 6.0 | 3.0 | 4.0 | 5.0 | 6.0 | 2.0 | NaN | NaN | PATRONATO |
| 5 | ATIVO | 180.0 | 157.0 | 4005446 | MAIZA SEVERINA DA SILVA | 1980-07-03 00:00:00 | 0.0 | 1.0 | SEVERINA MARIA DA SILVA | 0 | NaN | NaN | 8.198375e+10 | 6.0 | 3.0 | 4.0 | 3.0 | 6.0 | 2.0 | NaN | NaN | PATRONATO |
| 6 | ATIVO | 181.0 | 158.0 | 4005447 | VALDILENE MARTINS DA SILVA | 1984-11-11 00:00:00 | 0.0 | 1.0 | MARIA GORETE MARTINS DA SILVA | 0 | NaN | NaN | NaN | 6.0 | 5.0 | 4.0 | NaN | 6.0 | 2.0 | NaN | NaN | URA |
| 7 | ATIVO | 188.0 | 165.0 | 4005491 | EDRIANA WILMA DA SILVA | 1977-06-20 00:00:00 | 0.0 | 1.0 | MARLEIDE DA SILVA | 0 | NaN | NaN | 8.198982e+10 | 6.0 | 6.0 | 4.0 | 4.0 | 6.0 | 2.0 | NaN | NaN | URA |
| 8 | ATIVO | 190.0 | 167.0 | 4005501 | MARILENE CRISTINA DOS PRAZERES MENDES | 1977-01-14 00:00:00 | 0.0 | 1.0 | MARIA DOS PRAZERES MENDES | MARCOS ANTÔNIO MENDES | NaN | NaN | NaN | 6.0 | 6.0 | 4.0 | 4.0 | 6.0 | 2.0 | NaN | NaN | URA |
| 9 | ATIVO | 199.0 | 176.0 | 4005518 | SUZANA INÊS DOS SANTOS | 1979-10-08 00:00:00 | 0.0 | 1.0 | JOSEFA INÊZ DOS SANTOS | SEBASTIÃO BELO DOS SANTOS | NaN | NaN | NaN | 6.0 | 7.0 | 4.0 | 2.0 | 6.0 | 2.0 | NaN | NaN | URA |
| ATIVO | PESSOA_FISICA_ID | Prontuário SIAP ? | NUMERO_PRONTUARIO | NOME_COMPLETO | DATA_NASCIMENTO | IDADE_ESTIMADA | NACIONALIDADE_ID | NOME_MAE | NOME_PAI | NUMERO_CPF | NUMERO_RG | NUMERO_TEL_CEL | TIPO_DEFICIENCIA_ID | ESCOLARIDADE_ID | ESTADO_CIVIL_ID | ESTADO_ECONOMICO_ID | PROFISSAO_ID | SEXO_ID | ORIENTACAO_SEXUAL_ID | IDENTIDADE_GENERO_ID | SIGLA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46396 | ATIVO | 1033966.0 | 580676.0 | 20250823 | ELIOMAR JOSE CABRERA BARRETO | 1992-07-17 | NaN | 1.0 | ELIOMAR VICITACION CABRERA BASTARDO | PAI NÃO DECLARADO | 70912751282 | NaN | 8.286369e+09 | 5.0 | 7.0 | 5.0 | 2.0 | 581.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46397 | ATIVO | 1033977.0 | 580696.0 | 20250841 | GUSTAVO ANTONIO DE LIRA | 1998-06-30 | NaN | 1.0 | MARIA DE LOURDES DE AMANCIO DE LIRA | GILSON ANTONIO DE LIRA | NaN | NaN | 8.198754e+10 | 5.0 | 6.0 | 4.0 | 2.0 | 830.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46398 | ATIVO | 1034583.0 | 580936.0 | 20250899 | ANDREIA CARLA MARTINS CAVALCANTI | 1981-09-13 | NaN | 1.0 | GERUSA MARIA DA SILVA MARTINS | Desconhecido/Não Declarado | NaN | NaN | NaN | 5.0 | 8.0 | 1.0 | 2.0 | 681.0 | 2.0 | 26.0 | 26.0 | PATRONATO |
| 46399 | ATIVO | 1033982.0 | 580698.0 | 20250853 | ALEX MANOEL DA SILVA | 1980-07-27 | NaN | 1.0 | OSANA IZABEL DA SILVA | MANOEL ANTONIO DA SILVA | 04004806461 | NaN | 8.199274e+10 | 5.0 | 3.0 | 2.0 | 1.0 | 738.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46400 | ATIVO | 1034668.0 | 580995.0 | 20250893 | MARIA IRIS NATALY COSTA E SILVA | 1990-03-08 | NaN | 1.0 | SUELY COSTA E SILVA | PAI NÃO DECLARADO | 09965066400 | NaN | 8.198633e+10 | 5.0 | 7.0 | 4.0 | 1.0 | 346.0 | 2.0 | 26.0 | 26.0 | PATRONATO |
| 46401 | ATIVO | 1033975.0 | 580695.0 | 20250829 | CRISTIANO GERONIMO DOS SANTOS | 1958-02-07 | NaN | 1.0 | OVIDIA GERONIMO DOS SANTOS | NÃO DECLARADO | 19231040472 | NaN | 8.199645e+10 | 5.0 | 3.0 | 2.0 | 2.0 | 651.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46402 | ATIVO | 1033981.0 | 580697.0 | 20250852 | NARTACHE DRIELLY ALVES CORREIA | 1991-04-26 | NaN | 1.0 | ANA MARIA CORREIA | JOSE ALVES DOS SANTOS | 08652431400 | NaN | 8.198643e+10 | 5.0 | 7.0 | 4.0 | 9.0 | 534.0 | 2.0 | 26.0 | 26.0 | PATRONATO |
| 46403 | ATIVO | 1034103.0 | 580718.0 | 20250870 | JOSUEL DOS SANTOS | 1976-08-09 | NaN | 1.0 | MARIA DIVANE DOS SANTOS | AMARO FRANCISCO DOS SANTOS | 70221792473 | NaN | 8.199773e+10 | 5.0 | 15.0 | 5.0 | 1.0 | 636.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46404 | ATIVO | 1034765.0 | 581036.0 | 20250905 | RAFAEL JORDAO ACCIOLY | 1996-01-02 | NaN | 1.0 | SILENE JORDAO DE OLIVEIRA | EVAN JOSE DE BARROS ACCIOLY FILHO | NaN | NaN | NaN | 5.0 | 6.0 | 4.0 | 2.0 | 659.0 | 1.0 | 26.0 | 26.0 | PATRONATO |
| 46405 | ATIVO | 1034783.0 | 581037.0 | 20250908 | RICARDO FREDERICO DA ROCHA E SILVA | 1982-11-13 | NaN | 1.0 | CREUZA MARIA DE OLIVEIRA | FELIX NOLE DA ROCHA E SILVA FILHO | 04595924402 | NaN | 8.199623e+10 | 5.0 | 6.0 | 4.0 | 3.0 | 851.0 | 1.0 | 26.0 | 26.0 | PATRONATO |